

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Set Up a Database Repository [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Set Up Database Model Files,Set Up,Set Up Database Model Files,Database Repository,Database Repository Set Up,Database Repository Create,Database Repository Connect To,Repository,Repository Set Up Database,Repository Create,Repository Connect To,Upsize,Upsize From Desktop and Professional Editions,Desktop Edition,Desktop Edition Upsize From,Professional Edition,Professional Edition Upsize From,MS Jet,MS Jet Database As Model Repository">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Set Up a Database Repository</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="model_wizard.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="upsize_to_access_2007.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Introduction</span></p>
<p class="p_BodyText"><span class="f_BodyText">The Desktop and Professional versions of Enterprise Architect use an MS JET database as the model repository.</span></p>
<p class="p_BodyText"><span class="f_BodyText">If you purchase the </span><span class="f_BodyText">Corporate, </span><span class="f_BodyText">Business and Software Engineering, Systems Engineering or Ultimate edition, you can create and use any of the following data repositories:</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1"><a href="createanewsqlserverreposi.htm">SQL Server</a> 2000, 2005 or 2008</span></li>
<li><span class="f_Bulletlist1"><a href="createanewmysqlrepository.htm">MySQL</a> 4 or 5</span></li>
<li><span class="f_Bulletlist1"><a href="createanewpostgresqlreposi.htm">PostgreSQL</a> 7 or 8</span></li>
<li><span class="f_Bulletlist1"><a href="createanewadaptiveservera.htm">Adaptive Server Anywhere 8 or 9, or SQL Anywhere 10 or 11</a></span></li>
<li><span class="f_Bulletlist1"><a href="access_2007.htm">Access 2007</a></span></li>
<li><span class="f_Bulletlist1"><a href="createnewprogressopenedge.htm">Progress OpenEdge</a></span></li>
<li><span class="f_Bulletlist1"><a href="createanewmsdeserverrepos.htm">MSDE</a> or </span></li>
<li><span class="f_Bulletlist1"><a href="createaneworacle9iserverrep.htm">Oracle 9i, 10g or 11g</a>.</span></li>
</ul>
<p class="p_BodyText"><span class="f_BodyText">You </span><span class="f_BodyText" style="font-style: italic;">upsize</span><span class="f_BodyText"> the Enterprise Architect models (either existing or template) to use your selected DBMS. The process of upsizing a model is straightforward and comprises the following steps:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Install the DBMS software and create a database.</span></li>
<li value=2><span class="f_NumberedList">Run a script supplied by Sparx Systems (</span><span class="f_BodyText"><a href="http://www.sparxsystems.com/registered/reg_ea_corp_ed.html" target="_blank" class="weblink">www.sparxsystems.com/registered/reg_ea_corp_ed.html)</a> </span><span class="f_NumberedList">to create the required tables.</span></li>
<li value=3><span class="f_NumberedList">Open Enterprise Architect and use the <a href="datatransfer2.htm">Project Data Transfer</a> function (select the </span><span class="f_MenuKeyField">Tools | Data Management | Project Transfer</span><span class="f_NumberedList"> menu option) to move a model from a .EAP file to the DBMS repository.</span></li>
</ol>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">You cannot move a model from a source .EAP file of a version earlier than 3.5.0.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">Setting up a database repository is a two- or three-stage process: firstly, you set up an ODBC driver for your database; secondly, you create the repository tables using scripts downloaded from the Sparx Systems web site; and finally, you connect to the repository. Full instructions on all three stages are provided below.</span></p>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Set Up an ODBC Driver</span></p>
<p class="p_BodyText"><span class="f_BodyText">Setting up an ODBC driver is only necessary for </span><span class="f_BodyText" style="font-style: italic;">MySQL</span><span class="f_BodyText">, </span><span class="f_BodyText" style="font-style: italic;">PostgreSQL, Progress OpenEdge</span><span class="f_BodyText"> and </span><span class="f_BodyText" style="font-style: italic;">Adaptive Server Anywhere</span><span class="f_BodyText">. The other supported databases connect using OLE DB, so this stage can be skipped. To find out how to set up an ODBC driver, go to:</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1"><a href="setupmysqlodbcdriver.htm">Set Up a MySQL ODBC Driver</a></span></li>
<li><span class="f_Bulletlist1"><a href="setupapostgresqlodbcdriver.htm">Set Up a PostgreSQL ODBC Driver</a></span></li>
</ul>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1"><a href="setupanadaptiveserveranywh.htm">Set Up an Adaptive Server Anywhere ODBC Driver</a></span></li>
<li><span class="f_Bulletlist1"><a href="setupprogressopenedgeodbc.htm">Set Up a Progress OpenEdge ODBC Driver</a>.</span></li>
</ul>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Create a Repository</span></p>
<p class="p_BodyText"><span class="f_BodyText">To find out how to download the scripts and create the data repository tables, go to:</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1"><a href="createanewmysqlrepository.htm">Create a MySQL Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="access_2007.htm">Create an Access 2007 Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createanewsqlserverreposi.htm">Create a SQL Server Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createaneworacle9iserverrep.htm">Create an Oracle Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createanewpostgresqlreposi.htm">Create a PostgreSQL Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createanewadaptiveservera.htm">Create an Adaptive Server Anywhere Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createanewmsdeserverrepos.htm">Create an MSDE Server Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="createnewprogressopenedge.htm">Create a Progress OpenEdge Data Repository</a></span></li>
</ul>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Connect to a Repository</span></p>
<p class="p_BodyText"><span class="f_BodyText">Once the repository is created, you can connect to it. To find out how, go to:</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1"><a href="connecttomysql.htm">Connect to a MySQL Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connecttosqlserver.htm">Connect to a SQL Server Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connecttoaoracle9idatarep.htm">Connect to an Oracle Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connecttoapostgresqlreposi.htm">Connect to a PostgreSQL Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connecttoanadaptiveserver.htm">Connect to an Adaptive Server Anywhere Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connecttoamsdeserverdata.htm">Connect to an MSDE Server Data Repository</a></span></li>
<li><span class="f_Bulletlist1"><a href="connect_to_a_progress_openedge.htm">Connect to a Progress OpenEdge Data Repository.</a></span></li>
</ul>




            </div>
          </div>
        </div>



</div>


</body>
</html>
